﻿/**
 *	主要功能：
 *      1.资料类型初始化
 *      2.关键字初始化
 *      3.流程初始化
 *  作者：liuzhh
 */

/** T_COMM_SEQUENCE **/
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_SYS_DICTTYPE', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('S_SECU_USER', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('S_SECU_ROLE', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('S_SECU_RESOURCE', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('S_SECU_ROLE_RELA_RESOURCE', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_PRODUCT_REFERENCE', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_COMM_ATTACH', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_PRODUCT_MANAGER', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_PRODUCT_SORT', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_PRODUCT', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_PRODUCT_DICT', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_PRODUCT_SORT_REF', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_PRODUCT_INFO', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_SHARE_REFERENCE', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('S_SECU_ROLE_RELA_USER', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_SYS_DICTTYPE', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_SYS_DICT', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_PRODUCT', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_PRODUCT_SORT', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_PRODUCT_REF_PRODUCT', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_ORGAN_LINKMETHOD', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_ORGAN_ORGANIZATION', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_ORGAN_ORG_RELA_PERSON', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_ORGAN_PERSON', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BPM_NEXTTEP', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BPM_PROCESSSTEP', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BPM_PROCESSCONFIG', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BPM_TRANSACTOR', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BPM_PROC_TRAN_RECORD', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BPM_TRANSACTPROCESSSTATUS', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BPM_TRANSACTORTYPE', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BPM_PROCESSCONFIGDETAIL', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BUSI_BUSINESS_REQUEST', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_BPM_PART', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('S_BPM_PART_RELA_USER', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_CONTRACT_INFO', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values ('SEQ_CONTRACT_RECORD', 1);
insert into T_COMM_SEQUENCE (NAME, NEXT_VAL) values('SEQ_BPM_PROGRESS','1')
/** 修改T_COMM_SEQUENCE初始化值 **/
update T_COMM_SEQUENCE set NEXT_VAL=20 where name='S_SECU_RESOURCE';
update T_COMM_SEQUENCE set NEXT_VAL=4 where name='S_SECU_ROLE';
update T_COMM_SEQUENCE set NEXT_VAL=11 where name='S_SECU_ROLE_RELA_RESOURCE';
update T_COMM_SEQUENCE set NEXT_VAL=2 where name='S_SECU_USER';
update T_COMM_SEQUENCE set NEXT_VAL=2 where name='SEQ_ORGAN_PERSON';
update T_COMM_SEQUENCE set NEXT_VAL=2 where name='S_SECU_ROLE_RELA_USER';
update T_COMM_SEQUENCE set NEXT_VAL=5 where name='SEQ_SYS_DICTTYPE';
update T_COMM_SEQUENCE set NEXT_VAL=11 where name='SEQ_SYS_DICT';

/** T_SECU_RESOURCE **/
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('1', 'OBJECT', '数据字典类型模块', 'MODULE_DICTTYPE', 'MODULE_DICTTYPE', 'admin', to_date('16-01-2008', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 101);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('2', 'OBJECT', '用户管理模块', 'SECU_USER', 'SECU_USER', 'admin', to_date('24-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'), 100);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('3', 'OBJECT', '角色管理模块', 'SECU_ROLE', 'SECU_ROLE', 'admin', to_date('24-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 104);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('4', 'OBJECT', '资源管理模块', 'SECU_RESOURCE', 'SECU_RESOURCE', 'admin', to_date('24-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'), 102);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('5', 'MENU', '系统管理', 'MENU_SYSMAN', 'security/listUser.action', 'admin', to_date('30-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 5);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('6', 'OBJECT', '数据字典模块', 'MODULE_DICT', 'MODULE_DICT', 'admin', to_date('24-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'), 103);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('7', 'MENU', '产品目录', 'MENU_CATALOG', 'business/product/listProduct.action', null, to_date('29-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 2);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('8', 'MENU', '首页', 'MENU_INDEX', 'common/index.action', null, to_date('29-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 1);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('9', 'MENU', '共享资料', 'MENU_SHAREREF', 'business/share/listShareReference.action?refType=ITV_SHARE', null, to_date('29-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 3);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('10', 'MENU', '虚拟团队', 'MENU_NEWPRODUCT', 'common/toForum.action', null, to_date('29-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 4);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('11', 'MODELMENU', '产品目录_产品视图', 'PRODUCTVIEW', 'PRODUCTVIEW', 'admin', to_date('24-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 1);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('12', 'MODELMENU', '产品目录_产品目录', 'PRODUCTCATALOG', 'PRODUCTCATALOG', 'admin', to_date('24-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 2);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('13', 'MODELMENU', '产品目录_产品目录维护', 'CATALOGMANAGE', 'CATALOGMANAGE', 'admin', to_date('24-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 3);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('14', 'MODELMENU', '产品目录_产品维护', 'PRODUCTMANAGE', 'PRODUCTMANAGE', 'admin', to_date('24-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 4);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('15', 'MODELMENU', '产品目录_产品字典', 'PRODUCTDICT', 'PRODUCTDICT', 'admin', to_date('24-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 5);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('16', 'MODELMENU', '产品目录_资料信息', 'PRODUCTREFERENCE', 'PRODUCTREFERENCE', 'admin', to_date('24-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 6);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('17', 'MODELMENU', '产品目录_产品资料维护', 'REFERENCEMANAGE', 'REFERENCEMANAGE', 'admin', to_date('24-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'), 7);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('18', 'MODELMENU', '产品目录_产品管理人员', 'PRODUCTMANAGER', 'PRODUCTMANAGER', 'admin', to_date('24-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'), 8);
insert into T_SECU_RESOURCE (ID, RESOURCE_TYPE, NAME, KEY, VALUE, CREATOR, BEGIN, END, DISPORT)
values ('19', 'MODELMENU', '产品目录_管理人员维护', 'MANAGEROP', 'MANAGEROP', 'admin', to_date('24-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'), 9);

/** T_SECU_ROLE **/
insert into T_SECU_ROLE (ID, NAME, DESCRIPTION, CREATOR, BEGIN, END)
values ('1', '系统管理员', '对系统的所有功能具有操作权限。', 'admin', to_date('22-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'));
insert into T_SECU_ROLE (ID, NAME, DESCRIPTION, CREATOR, BEGIN, END)
values ('2', '普通员工', '具有基本系统基本功能。', 'admin', to_date('22-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SECU_ROLE (ID, NAME, DESCRIPTION, CREATOR, BEGIN, END)
values ('3', '资料管理员', '对资料管理模块具有管理权限。', 'admin', to_date('22-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));

/** T_SECU_ROLE_RELA_RESOURCE **/
insert into T_SECU_ROLE_RELA_RESOURCE (ID, SECU_ROLE, SECU_RESOURCE, CREATOR, BEGIN, END)
values ('1', '1', '1', 'admin', to_date('08-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SECU_ROLE_RELA_RESOURCE (ID, SECU_ROLE, SECU_RESOURCE, CREATOR, BEGIN, END)
values ('2', '1', '2', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SECU_ROLE_RELA_RESOURCE (ID, SECU_ROLE, SECU_RESOURCE, CREATOR, BEGIN, END)
values ('3', '1', '3', 'admin', to_date('08-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SECU_ROLE_RELA_RESOURCE (ID, SECU_ROLE, SECU_RESOURCE, CREATOR, BEGIN, END)
values ('4', '1', '4', 'admin', to_date('08-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SECU_ROLE_RELA_RESOURCE (ID, SECU_ROLE, SECU_RESOURCE, CREATOR, BEGIN, END)
values ('5', '1', '5', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SECU_ROLE_RELA_RESOURCE (ID, SECU_ROLE, SECU_RESOURCE, CREATOR, BEGIN, END)
values ('6', '1', '6', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SECU_ROLE_RELA_RESOURCE (ID, SECU_ROLE, SECU_RESOURCE, CREATOR, BEGIN, END)
values ('7', '1', '7', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SECU_ROLE_RELA_RESOURCE (ID, SECU_ROLE, SECU_RESOURCE, CREATOR, BEGIN, END)
values ('8', '1', '8', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SECU_ROLE_RELA_RESOURCE (ID, SECU_ROLE, SECU_RESOURCE, CREATOR, BEGIN, END)
values ('9', '1', '9', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SECU_ROLE_RELA_RESOURCE (ID, SECU_ROLE, SECU_RESOURCE, CREATOR, BEGIN, END)
values ('10', '1', '10', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));

/** T_ORGAN_PERSON 初始化用户admin **/
insert into T_ORGAN_PERSON (ID, NAME, LAST_NAME, FIRST_NAME, SEX, BIRTHDAY, CREATOR, BEGIN, END)
values ('1', 'ADMIN', 'admin', 'admin', 1, to_date('03-04-1981', 'dd-mm-yyyy'), '1', to_date('20-03-2009', 'dd-mm-yyyy'), to_date('01-03-3010', 'dd-mm-yyyy'));

/** T_SECU_USER 初始化用户admin **/
insert into T_SECU_USER (ID, USER_ID, PERSON, SYSN_CODE, CREATOR, LAST_LOGIN_TIME, LAST_UPDATE_TIME, LAST_MODIFY_TIME, BEGIN, END, PASSWORD, IS_VALID, FORUM_PASSWORD)
values ('1', 'admin', '1', 'admin', 'admin', to_date('21-03-2009', 'dd-mm-yyyy'), to_date('08-04-2009', 'dd-mm-yyyy'), to_date('21-03-2009', 'dd-mm-yyyy'), to_date('21-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'), 'admin', '1', 'adminfjii');

/** t_organ_organization **/
insert into t_organ_organization (ID, NAME, ORG_TYPE, ORG_LEVEL, DESCRIPTION, AUTHOR, CREATOR, BEGIN, END, ORG_INDEX, CODE_ID, SUPERIOR)
values ('0', '中国电信福建公司', 'CORP', 0, '中国电信福建公司', '0', 'admin', to_date('21-04-2009', 'dd-mm-yyyy'), to_date('30-12-9999', 'dd-mm-yyyy'), '0', '0', '');

/** T_SECU_ROLE_RELA_USER **/
insert into T_SECU_ROLE_RELA_USER (ID, SECU_USER, SECU_ROLE, CREATOR, BEGIN, END)
values ('1', '1', '1', 'admin', to_date('24-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));

/** T_SYS_DICTTYPE **/
insert into T_SYS_DICTTYPE (ID, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('1', '用户有效性', 'USER_VALID', 'admin', to_date('22-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SYS_DICTTYPE (ID, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('2', '共享资料类型', 'SHARE_TYPE', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'));
insert into T_SYS_DICTTYPE (ID, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('3', '资料类型', 'PRODUCTREFERENCE', 'admin', to_date('21-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'));
insert into T_SYS_DICTTYPE (ID, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('4', '产品类型', 'PRODUCT_TYPE', 'admin', to_date('21-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));

/** T_SYS_DICT **/
insert into T_SYS_DICT (ID, DICT_TYPE, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('3', '3', '操作说明书', 'REF_OP_DESCRIP', 'admin', to_date('25-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SYS_DICT (ID, DICT_TYPE, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('1', '1', '有效', '1', 'admin', to_date('22-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SYS_DICT (ID, DICT_TYPE, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('2', '2', '无效', '0', 'admin', to_date('22-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SYS_DICT (ID, DICT_TYPE, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('4', '4', '增值类', 'ZZL', 'admin', to_date('21-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SYS_DICT (ID, DICT_TYPE, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('5', '3', '产品说明书', 'PRODUCT_REFERENCE', 'admin', to_date('20-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SYS_DICT (ID, DICT_TYPE, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('6', '2', 'ITV资料共享', 'ITV_SHARE', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'));
insert into T_SYS_DICT (ID, DICT_TYPE, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('7', '2', '通报信息', 'COMINFO_SHARE', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SYS_DICT (ID, DICT_TYPE, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('8', '2', '市场分析资料', 'MARKINFO_SHARE', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));
insert into T_SYS_DICT (ID, DICT_TYPE, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('9', '2', '营销策划方案', 'SHOP_SHARE', 'admin', to_date('22-04-2009', 'dd-mm-yyyy'), to_date('16-01-2280', 'dd-mm-yyyy'));
insert into T_SYS_DICT (ID, DICT_TYPE, NAME, KEY_VALUE, CREATOR, BEGIN, END)
values ('10', '3', '管理办法', 'METHOD', 'admin', to_date('21-03-2009', 'dd-mm-yyyy'), to_date('16-01-2280 09:32:48', 'dd-mm-yyyy hh24:mi:ss'));

/**同步组织和用户**/
drop table prj_sareacode;
drop table prj_sdept;
drop table prj_suser;
drop table prj_suserdept;
create table prj_sareacode as select * from sareacode@dblink_project;
create table prj_sdept as select * from sdept@dblink_project;
create table prj_suser as select * from suser@dblink_project;
create table prj_suserdept as select * from suserdept@dblink_project;
commit;
call PROD_SYSN_ALL();
commit;

/**创建合同表**/
drop table project_docu_template;
create table project_docu_template as select * from vOADocuTemplate@dblink_project;
drop table project_contract;
create table project_contract as select * from VOACONTRACT@dblink_project;
drop table project_task;
create table project_task as select * from VOACURRFLOW@dblink_project;

commit;